/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 25/12/2018 11:03:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_name` varchar(4) DEFAULT NULL COMMENT '名称',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `phone` varchar(32) DEFAULT '0' COMMENT '手机号码',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (2, NULL, NULL, '0');
INSERT INTO `user` VALUES (11, '王五', '123456', '1104');
INSERT INTO `user` VALUES (13, '2', '1', '0');
INSERT INTO `user` VALUES (14, '王五1', '123456', '1104');
INSERT INTO `user` VALUES (15, '王五0', '123456', '1104');
INSERT INTO `user` VALUES (16, '王五0', '123456', '1104');
INSERT INTO `user` VALUES (17, '王五9', '123456', '1104');
INSERT INTO `user` VALUES (18, '王五9', '123456', '1104');
INSERT INTO `user` VALUES (19, '王五9', '123456', '1104');
INSERT INTO `user` VALUES (23, '王五', '12345', '1104');
INSERT INTO `user` VALUES (24, '王五', '12345', '1104');
INSERT INTO `user` VALUES (25, '王五', '12345', '1104');
INSERT INTO `user` VALUES (26, '王五', '12345', '1104');
INSERT INTO `user` VALUES (27, '王五', '12345', '1104');
INSERT INTO `user` VALUES (28, '王五', '12345', '1104');
INSERT INTO `user` VALUES (29, '王五', '12345', '1104');
INSERT INTO `user` VALUES (30, '王五', '12345', '1104');
INSERT INTO `user` VALUES (31, '王五', '12345', '1104');
INSERT INTO `user` VALUES (32, '王五', '12345', '1104');
INSERT INTO `user` VALUES (33, '王五', '12345', '1104');
INSERT INTO `user` VALUES (34, '王五', '12345', '1104');
INSERT INTO `user` VALUES (35, '王五', '12345', '1104');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
